##############################################################################
# Python From Scratch
# Autor: Nilo Ney Coutinho Menezes
# Editora Novatec (c) 2010-2024
# Site: https://pythonfromscratch.com
#
# File: listing\chapter 11\11.1481 - No Title.py
# Description: No Title
##############################################################################

import sqlite3
from contextlib import closing

with sqlite3.connect("phonebook.db") as connection:
    with closing(connection.cursor()) as cursor:
        cursor.execute("""update phonebook
                              set telephone = '12345-6789' """)
        print("Updated records: ", cursor.rowcount)
        if cursor.rowcount == 1:
            connection.commit()
            print("Saved changes")
        else:
            connection.rollback()
            print("Updates aborted")